Navicat allows you to backup your database/schema/table(s) using the Dump SQL File feature.
- Select the database/schema/table(s).
- Control-click and select Dump SQL File from the popup menu. If you select database/schema, you can choose dump Structure + Data or Structure only.
- Save the sql file to your destination.
See also:
Execute SQL File